-- 生成 GEN_TABLE 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_GEN_TABLE_ID INCREMENT 1 MINVALUE 1 START 14 NO CACHE NO CYCLE;

-- 生成 GEN_TABLE_COLUMN 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_GEN_TABLE_COLUMN_ID INCREMENT 1 MINVALUE 1 START 14 NO CACHE NO CYCLE;

-- 生成 SYS_CONFIG 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_CONFIG_ID INCREMENT 1 MINVALUE 1 START 7 NO CACHE NO CYCLE;

-- 生成 SYS_DEPT 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_DEPT_ID INCREMENT 1 MINVALUE 1 START 110 NO CACHE NO CYCLE;

-- 生成 SYS_DICT_DATA 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_DICT_DATA_ID INCREMENT 1 MINVALUE 1 START 30 NO CACHE NO CYCLE;

-- 生成 SYS_DICT_TYPE 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_DICT_TYPE_ID INCREMENT 1 MINVALUE 1 START 11 NO CACHE NO CYCLE;

-- 生成 SYS_JOB 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_JOB_ID INCREMENT 1 MINVALUE 1 START 102 NO CACHE NO CYCLE;

-- 生成 SYS_JOB_LOG 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_JOB_LOG_ID INCREMENT 1 MINVALUE 1 START 1 NO CACHE NO CYCLE;

-- 生成 SYS_LOGININFOR 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_LOGININFOR_ID INCREMENT 1 MINVALUE 1 START 102 NO CACHE NO CYCLE;

-- 生成 SYS_MENU 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_MENU_ID INCREMENT 1 MINVALUE 1 START 1061 NO CACHE NO CYCLE;

-- 生成 SYS_NOTICE 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_NOTICE_ID INCREMENT 1 MINVALUE 1 START 3 NO CACHE NO CYCLE;

-- 生成 SYS_OPER_LOG 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_OPER_LOG_ID INCREMENT 1 MINVALUE 1 START 1 NO CACHE NO CYCLE;

-- 生成 SYS_POST 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_POST_ID INCREMENT 1 MINVALUE 1 START 5 NO CACHE NO CYCLE;

-- 生成 SYS_ROLE 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_ROLE_ID INCREMENT 1 MINVALUE 1 START 3 NO CACHE NO CYCLE;

-- 生成 SYS_USER 表的序列
CREATE SEQUENCE RY_VUE_SHENTONG.SEQ_SYS_USER_ID INCREMENT 1 MINVALUE 1 START 3 NO CACHE NO CYCLE;



CREATE TABLE RY_VUE_SHENTONG.GEN_TABLE
(
    TABLE_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_GEN_TABLE_ID.NEXTVAL,
    TABLE_NAME character varying(200) DEFAULT '' ,
    TABLE_COMMENT character varying(500) DEFAULT '' ,
    SUB_TABLE_NAME character varying(64) ,
    SUB_TABLE_FK_NAME character varying(64) ,
    CLASS_NAME character varying(100) DEFAULT '' ,
    TPL_CATEGORY character varying(200) DEFAULT 'crud' ,
    TPL_WEB_TYPE character varying(30) DEFAULT '' ,
    PACKAGE_NAME character varying(100) ,
    MODULE_NAME character varying(30) ,
    BUSINESS_NAME character varying(30) ,
    FUNCTION_NAME character varying(50) ,
    FUNCTION_AUTHOR character varying(50) ,
    GEN_TYPE character(1) DEFAULT '0' ,
    GEN_PATH character varying(200) DEFAULT '/' ,
    OPTIONS character varying(1000) ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(500) , 
    CONSTRAINT GEN_TABLE_PK PRIMARY KEY (TABLE_ID)
)  
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.GEN_TABLE_COLUMN
(
    COLUMN_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_GEN_TABLE_COLUMN_ID.NEXTVAL,
    TABLE_ID bigint ,
    COLUMN_NAME character varying(200) ,
    COLUMN_COMMENT character varying(500) ,
    COLUMN_TYPE character varying(100) ,
    JAVA_TYPE character varying(500) ,
    JAVA_FIELD character varying(200) ,
    IS_PK character(1) ,
    IS_INCREMENT character(1) ,
    IS_REQUIRED character(1) ,
    IS_INSERT character(1) ,
    IS_EDIT character(1) ,
    IS_LIST character(1) ,
    IS_QUERY character(1) ,
    QUERY_TYPE character varying(200) DEFAULT 'EQ' ,
    HTML_TYPE character varying(200) ,
    DICT_TYPE character varying(200) DEFAULT '' ,
    SORT integer ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone , 
    CONSTRAINT GEN_TABLE_COLUMN_PK PRIMARY KEY (COLUMN_ID)
)  
 BINLOG ON ;
--Indexes DDL



CREATE TABLE RY_VUE_SHENTONG.QRTZ_CALENDARS
(
    SCHED_NAME character varying(120) NOT NULL,
    CALENDAR_NAME character varying(200) NOT NULL,
    CALENDAR blob NOT NULL, 
    CONSTRAINT QRTZ_CALENDARS_PK PRIMARY KEY (SCHED_NAME, CALENDAR_NAME)
)  
 BINLOG ON ;
--Indexes DDL




CREATE TABLE RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS
(
    SCHED_NAME character varying(120) NOT NULL,
    ENTRY_ID character varying(95) NOT NULL,
    TRIGGER_NAME character varying(200) NOT NULL,
    TRIGGER_GROUP character varying(200) NOT NULL,
    INSTANCE_NAME character varying(200) NOT NULL,
    FIRED_TIME bigint NOT NULL,
    SCHED_TIME bigint NOT NULL,
    "PRIORITY" integer NOT NULL,
    STATE character varying(16) NOT NULL,
    JOB_NAME character varying(200) ,
    JOB_GROUP character varying(200) ,
    IS_NONCONCURRENT character varying(1) ,
    REQUESTS_RECOVERY character varying(1) , 
    CONSTRAINT QRTZ_FIRED_TRIGGERS_PK PRIMARY KEY (SCHED_NAME, ENTRY_ID)
)  
 BINLOG ON ;
--Indexes DDL



CREATE TABLE RY_VUE_SHENTONG.QRTZ_LOCKS
(
    SCHED_NAME character varying(120) NOT NULL,
    LOCK_NAME character varying(40) NOT NULL, 
    CONSTRAINT QRTZ_LOCKS_PK PRIMARY KEY (SCHED_NAME, LOCK_NAME)
)  
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.QRTZ_PAUSED_TRIGGER_GRPS
(
    SCHED_NAME character varying(120) NOT NULL,
    TRIGGER_GROUP character varying(200) NOT NULL, 
    CONSTRAINT QRTZ_PAUSED_TRIGGER_GRPS_PK PRIMARY KEY (SCHED_NAME, TRIGGER_GROUP)
)  
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.QRTZ_SCHEDULER_STATE
(
    SCHED_NAME character varying(120) NOT NULL,
    INSTANCE_NAME character varying(200) NOT NULL,
    LAST_CHECKIN_TIME bigint NOT NULL,
    CHECKIN_INTERVAL bigint NOT NULL, 
    CONSTRAINT QRTZ_SCHEDULER_STATE_PK PRIMARY KEY (SCHED_NAME, INSTANCE_NAME)
)  
 BINLOG ON ;
--Indexes DDL

CREATE TABLE RY_VUE_SHENTONG.QRTZ_JOB_DETAILS
(
    SCHED_NAME character varying(120) NOT NULL,
    JOB_NAME character varying(200) NOT NULL,
    JOB_GROUP character varying(200) NOT NULL,
    "DESCRIPTION" character varying(250) ,
    JOB_CLASS_NAME character varying(250) NOT NULL,
    IS_DURABLE character varying(1) NOT NULL,
    IS_NONCONCURRENT character varying(1) NOT NULL,
    IS_UPDATE_DATA character varying(1) NOT NULL,
    REQUESTS_RECOVERY character varying(1) NOT NULL,
    JOB_DATA blob , 
    CONSTRAINT QRTZ_JOB_DETAILS_PK PRIMARY KEY (SCHED_NAME, JOB_NAME, JOB_GROUP)
)  
 BINLOG ON ;
--Indexes DDL




CREATE TABLE RY_VUE_SHENTONG.QRTZ_TRIGGERS
(
    SCHED_NAME character varying(120) NOT NULL,
    TRIGGER_NAME character varying(200) NOT NULL,
    TRIGGER_GROUP character varying(200) NOT NULL,
    JOB_NAME character varying(200) NOT NULL,
    JOB_GROUP character varying(200) NOT NULL,
    "DESCRIPTION" character varying(250) ,
    NEXT_FIRE_TIME bigint ,
    PREV_FIRE_TIME bigint ,
    "PRIORITY" integer ,
    TRIGGER_STATE character varying(16) NOT NULL,
    TRIGGER_TYPE character varying(8) NOT NULL,
    START_TIME bigint NOT NULL,
    END_TIME bigint ,
    CALENDAR_NAME character varying(200) ,
    MISFIRE_INSTR smallint ,
    JOB_DATA blob , 
    CONSTRAINT QRTZ_TRIGGERS_PK PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP), 
    CONSTRAINT QRTZ_TRIGGERS_IBFK_1 FOREIGN KEY (SCHED_NAME, JOB_NAME, JOB_GROUP) REFERENCES RY_VUE_SHENTONG.QRTZ_JOB_DETAILS(SCHED_NAME, JOB_NAME, JOB_GROUP)
)  
 BINLOG ON ;
--Indexes DDL
CREATE INDEX QRTZ_TRIGGERS_I_SCHED_NAME ON RY_VUE_SHENTONG.QRTZ_TRIGGERS USING BTREE(SCHED_NAME, JOB_NAME, JOB_GROUP) TABLESPACE SYSTEM INIT 64K NEXT 64K MAXSIZE UNLIMITED FILL 70 SPLIT 50;

CREATE TABLE RY_VUE_SHENTONG.QRTZ_BLOB_TRIGGERS
(
    SCHED_NAME character varying(120) NOT NULL,
    TRIGGER_NAME character varying(200) NOT NULL,
    TRIGGER_GROUP character varying(200) NOT NULL,
    BLOB_DATA blob , 
    CONSTRAINT QRTZ_BLOB_TRIGGERS_PK PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP), 
    CONSTRAINT QRTZ_BLOB_TRIGGERS_IBFK_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES RY_VUE_SHENTONG.QRTZ_TRIGGERS(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
)  
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.QRTZ_CRON_TRIGGERS
(
    SCHED_NAME character varying(120) NOT NULL,
    TRIGGER_NAME character varying(200) NOT NULL,
    TRIGGER_GROUP character varying(200) NOT NULL,
    CRON_EXPRESSION character varying(200) NOT NULL,
    TIME_ZONE_ID character varying(80) , 
    CONSTRAINT QRTZ_CRON_TRIGGERS_PK PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP), 
    CONSTRAINT QRTZ_CRON_TRIGGERS_IBFK_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES RY_VUE_SHENTONG.QRTZ_TRIGGERS(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
)  
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.QRTZ_SIMPLE_TRIGGERS
(
    SCHED_NAME character varying(120) NOT NULL,
    TRIGGER_NAME character varying(200) NOT NULL,
    TRIGGER_GROUP character varying(200) NOT NULL,
    REPEAT_COUNT bigint NOT NULL,
    REPEAT_INTERVAL bigint NOT NULL,
    TIMES_TRIGGERED bigint NOT NULL, 
    CONSTRAINT QRTZ_SIMPLE_TRIGGERS_PK PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP), 
    CONSTRAINT QRTZ_SIMPLE_TRIGGERS_IBFK_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES RY_VUE_SHENTONG.QRTZ_TRIGGERS(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
)  
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS
(
    SCHED_NAME character varying(120) NOT NULL,
    TRIGGER_NAME character varying(200) NOT NULL,
    TRIGGER_GROUP character varying(200) NOT NULL,
    STR_PROP_1 character varying(512) ,
    STR_PROP_2 character varying(512) ,
    STR_PROP_3 character varying(512) ,
    INT_PROP_1 integer ,
    INT_PROP_2 integer ,
    LONG_PROP_1 bigint ,
    LONG_PROP_2 bigint ,
    DEC_PROP_1 double precision ,
    DEC_PROP_2 double precision ,
    BOOL_PROP_1 character varying(1) ,
    BOOL_PROP_2 character varying(1) , 
    CONSTRAINT QRTZ_SIMPROP_TRIGGERS_PK PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP), 
    CONSTRAINT QRTZ_SIMPROP_TRIGGERS_IBFK_1 FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES RY_VUE_SHENTONG.QRTZ_TRIGGERS(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
)  
 BINLOG ON ;
--Indexes DDL



CREATE TABLE RY_VUE_SHENTONG.SYS_CONFIG
(
    CONFIG_ID integer NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_CONFIG_ID.NEXTVAL,
    CONFIG_NAME character varying(100) DEFAULT '' ,
    CONFIG_KEY character varying(100) DEFAULT '' ,
    CONFIG_VALUE character varying(500) DEFAULT '' ,
    CONFIG_TYPE character(1) DEFAULT 'N' ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(500) , 
    CONSTRAINT SYS_CONFIG_PK PRIMARY KEY (CONFIG_ID)
)
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_DEPT
(
    DEPT_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_DEPT_ID.NEXTVAL,
    PARENT_ID bigint DEFAULT 0 ,
    ANCESTORS character varying(50) DEFAULT '' ,
    DEPT_NAME character varying(30) DEFAULT '' ,
    ORDER_NUM integer DEFAULT 0 ,
    LEADER character varying(20) ,
    PHONE character varying(11) ,
    EMAIL character varying(50) ,
    STATUS character(1) DEFAULT '0' ,
    DEL_FLAG character(1) DEFAULT '0' ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone , 
    CONSTRAINT SYS_DEPT_PK PRIMARY KEY (DEPT_ID)
)
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_DICT_DATA
(
    DICT_CODE bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_DICT_DATA_ID.NEXTVAL,
    DICT_SORT integer DEFAULT 0 ,
    DICT_LABEL character varying(100) DEFAULT '' ,
    DICT_VALUE character varying(100) DEFAULT '' ,
    DICT_TYPE character varying(100) DEFAULT '' ,
    CSS_CLASS character varying(100) ,
    LIST_CLASS character varying(100) ,
    IS_DEFAULT character(1) DEFAULT 'N' ,
    STATUS character(1) DEFAULT '0' ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(500) , 
    CONSTRAINT SYS_DICT_DATA_PK PRIMARY KEY (DICT_CODE)
)
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_DICT_TYPE
(
    DICT_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_DICT_TYPE_ID.NEXTVAL,
    DICT_NAME character varying(100) DEFAULT '' ,
    DICT_TYPE character varying(100) DEFAULT '' ,
    STATUS character(1) DEFAULT '0' ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(500) , 
    CONSTRAINT SYS_DICT_TYPE_PK PRIMARY KEY (DICT_ID), 
    CONSTRAINT SYS_DICT_TYPE_DICT_TYPE_KEY UNIQUE (DICT_TYPE)
)
 BINLOG ON ;
--Indexes DDL



CREATE TABLE RY_VUE_SHENTONG.SYS_JOB
(
    JOB_ID bigint NOT NULL,
    JOB_NAME character varying(64) DEFAULT '' NOT NULL,
    JOB_GROUP character varying(64) DEFAULT 'DEFAULT' NOT NULL,
    INVOKE_TARGET character varying(500) NOT NULL,
    CRON_EXPRESSION character varying(255) DEFAULT '' ,
    MISFIRE_POLICY character varying(20) DEFAULT '3' ,
    CONCURRENT character(1) DEFAULT '1' ,
    STATUS character(1) DEFAULT '0' ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(500) DEFAULT '' , 
    CONSTRAINT SYS_JOB_PK PRIMARY KEY (JOB_ID, JOB_NAME, JOB_GROUP)
)  
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_JOB_LOG
(
    JOB_LOG_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_JOB_LOG_ID.NEXTVAL,
    JOB_NAME character varying(64) NOT NULL,
    JOB_GROUP character varying(64) NOT NULL,
    INVOKE_TARGET character varying(500) NOT NULL,
    JOB_MESSAGE character varying(500) ,
    STATUS character(1) DEFAULT '0' ,
    EXCEPTION_INFO character varying(2000) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone , 
    CONSTRAINT SYS_JOB_LOG_PK PRIMARY KEY (JOB_LOG_ID)
)  
 BINLOG ON ;
--Indexes DDL

CREATE TABLE RY_VUE_SHENTONG.SYS_LOGININFOR
(
    INFO_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_LOGININFOR_ID.NEXTVAL,
    USER_NAME character varying(50) DEFAULT '' ,
    IPADDR character varying(128) DEFAULT '' ,
    LOGIN_LOCATION character varying(255) DEFAULT '' ,
    BROWSER character varying(50) DEFAULT '' ,
    OS character varying(50) DEFAULT '' ,
    STATUS character(1) DEFAULT '0' ,
    MSG character varying(255) DEFAULT '' ,
    LOGIN_TIME timestamp(0) without time zone , 
    CONSTRAINT SYS_LOGININFOR_PK PRIMARY KEY (INFO_ID)
) BINLOG ON ;
--Indexes DDL
CREATE INDEX SYS_LOGININFOR_I_IDX_SYS_LOGININFOR_LT ON RY_VUE_SHENTONG.SYS_LOGININFOR USING BTREE(LOGIN_TIME) TABLESPACE SYSTEM INIT 64K NEXT 64K MAXSIZE UNLIMITED FILL 70 SPLIT 50;
CREATE INDEX SYS_LOGININFOR_I_IDX_SYS_LOGININFOR_S ON RY_VUE_SHENTONG.SYS_LOGININFOR USING BTREE(STATUS) TABLESPACE SYSTEM INIT 64K NEXT 64K MAXSIZE UNLIMITED FILL 70 SPLIT 50;


CREATE TABLE RY_VUE_SHENTONG.SYS_MENU
(
    MENU_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_MENU_ID.NEXTVAL,
    MENU_NAME character varying(50) NOT NULL,
    PARENT_ID bigint DEFAULT 0 ,
    ORDER_NUM integer DEFAULT 0 ,
    "PATH" character varying(200) DEFAULT '' ,
    COMPONENT character varying(255) ,
    "QUERY" character varying(255) ,
    IS_FRAME integer DEFAULT 1 ,
    IS_CACHE integer DEFAULT 0 ,
    MENU_TYPE character(1) DEFAULT '' ,
    "VISIBLE" character(1) DEFAULT '0' ,
    STATUS character(1) DEFAULT '0' ,
    PERMS character varying(100) ,
    ICON character varying(100) DEFAULT '#' ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(500) DEFAULT '' , 
    CONSTRAINT SYS_MENU_PK PRIMARY KEY (MENU_ID)
) BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_NOTICE
(
    NOTICE_ID integer NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_NOTICE_ID.NEXTVAL,
    NOTICE_TITLE character varying(50) NOT NULL,
    NOTICE_TYPE character(1) NOT NULL,
    NOTICE_CONTENT clob ,
    STATUS character(1) DEFAULT '0' ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(255) , 
    CONSTRAINT SYS_NOTICE_PK PRIMARY KEY (NOTICE_ID)
) BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_OPER_LOG
(
    OPER_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_OPER_LOG_ID.NEXTVAL,
    TITLE character varying(50) DEFAULT '' ,
    BUSINESS_TYPE integer DEFAULT 0 ,
    METHOD character varying(100) DEFAULT '' ,
    REQUEST_METHOD character varying(10) DEFAULT '' ,
    OPERATOR_TYPE integer DEFAULT 0 ,
    OPER_NAME character varying(50) DEFAULT '' ,
    DEPT_NAME character varying(50) DEFAULT '' ,
    OPER_URL character varying(255) DEFAULT '' ,
    OPER_IP character varying(128) DEFAULT '' ,
    OPER_LOCATION character varying(255) DEFAULT '' ,
    OPER_PARAM character varying(2000) DEFAULT '' ,
    JSON_RESULT character varying(2000) DEFAULT '' ,
    STATUS integer DEFAULT 0 ,
    ERROR_MSG character varying(2000) DEFAULT '' ,
    OPER_TIME timestamp(0) without time zone ,
    COST_TIME bigint DEFAULT 0 , 
    CONSTRAINT SYS_OPER_LOG_PK PRIMARY KEY (OPER_ID)
) BINLOG ON ;
--Indexes DDL
CREATE INDEX SYS_OPER_LOG_I_IDX_SYS_OPER_LOG_BT ON RY_VUE_SHENTONG.SYS_OPER_LOG USING BTREE(BUSINESS_TYPE) TABLESPACE SYSTEM INIT 64K NEXT 64K MAXSIZE UNLIMITED FILL 70 SPLIT 50;
CREATE INDEX SYS_OPER_LOG_I_IDX_SYS_OPER_LOG_OT ON RY_VUE_SHENTONG.SYS_OPER_LOG USING BTREE(OPER_TIME) TABLESPACE SYSTEM INIT 64K NEXT 64K MAXSIZE UNLIMITED FILL 70 SPLIT 50;
CREATE INDEX SYS_OPER_LOG_I_IDX_SYS_OPER_LOG_S ON RY_VUE_SHENTONG.SYS_OPER_LOG USING BTREE(STATUS) TABLESPACE SYSTEM INIT 64K NEXT 64K MAXSIZE UNLIMITED FILL 70 SPLIT 50;


CREATE TABLE RY_VUE_SHENTONG.SYS_POST
(
    POST_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_POST_ID.NEXTVAL,
    POST_CODE character varying(64) NOT NULL,
    POST_NAME character varying(50) NOT NULL,
    POST_SORT integer NOT NULL,
    STATUS character(1) NOT NULL,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(500) , 
    CONSTRAINT SYS_POST_PK PRIMARY KEY (POST_ID)
) BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_ROLE
(
    ROLE_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_ROLE_ID.NEXTVAL,
    ROLE_NAME character varying(30) NOT NULL,
    ROLE_KEY character varying(100) NOT NULL,
    ROLE_SORT integer NOT NULL,
    DATA_SCOPE character(1) DEFAULT '1' ,
    MENU_CHECK_STRICTLY smallint DEFAULT 1 ,
    DEPT_CHECK_STRICTLY smallint DEFAULT 1 ,
    STATUS character(1) NOT NULL,
    DEL_FLAG character(1) DEFAULT '0' ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(500) , 
    CONSTRAINT SYS_ROLE_PK PRIMARY KEY (ROLE_ID)
) BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_ROLE_DEPT
(
    ROLE_ID bigint NOT NULL,
    DEPT_ID bigint NOT NULL, 
    CONSTRAINT SYS_ROLE_DEPT_PK PRIMARY KEY (ROLE_ID, DEPT_ID)
) BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_ROLE_MENU
(
    ROLE_ID bigint NOT NULL,
    MENU_ID bigint NOT NULL, 
    CONSTRAINT SYS_ROLE_MENU_PK PRIMARY KEY (ROLE_ID, MENU_ID)
) BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_USER
(
    USER_ID bigint NOT NULL DEFAULT RY_VUE_SHENTONG.SEQ_SYS_USER_ID.NEXTVAL,
    DEPT_ID bigint ,
    USER_NAME character varying(30) NOT NULL,
    NICK_NAME character varying(30) NOT NULL,
    USER_TYPE character varying(2) DEFAULT '00' ,
    EMAIL character varying(50) DEFAULT '' ,
    PHONENUMBER character varying(11) DEFAULT '' ,
    SEX character(1) DEFAULT '0' ,
    AVATAR character varying(100) DEFAULT '' ,
    "PASSWORD" character varying(100) DEFAULT '' ,
    STATUS character(1) DEFAULT '0' ,
    DEL_FLAG character(1) DEFAULT '0' ,
    LOGIN_IP character varying(128) DEFAULT '' ,
    LOGIN_DATE timestamp(0) without time zone ,
    CREATE_BY character varying(64) DEFAULT '' ,
    CREATE_TIME timestamp(0) without time zone ,
    UPDATE_BY character varying(64) DEFAULT '' ,
    UPDATE_TIME timestamp(0) without time zone ,
    REMARK character varying(500) , 
    CONSTRAINT SYS_USER_PK PRIMARY KEY (USER_ID)
) BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_USER_POST
(
    USER_ID bigint NOT NULL,
    POST_ID bigint NOT NULL, 
    CONSTRAINT SYS_USER_POST_PK PRIMARY KEY (USER_ID, POST_ID)
)  
 BINLOG ON ;
--Indexes DDL


CREATE TABLE RY_VUE_SHENTONG.SYS_USER_ROLE
(
    USER_ID bigint NOT NULL,
    ROLE_ID bigint NOT NULL, 
    CONSTRAINT SYS_USER_ROLE_PK PRIMARY KEY (USER_ID, ROLE_ID)
)  
 BINLOG ON ;
--Indexes DDL



COMMENT ON TABLE RY_VUE_SHENTONG.sys_dept IS '部门表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.dept_id IS '部门id';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.parent_id IS '父部门id';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.ancestors IS '祖级列表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.dept_name IS '部门名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.order_num IS '显示顺序';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.leader IS '负责人';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.phone IS '联系电话';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.email IS '邮箱';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.status IS '部门状态（0正常 1停用）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.del_flag IS '删除标志（0代表存在 2代表删除）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dept.update_time IS '更新时间';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_user IS '用户信息表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.user_id IS '用户ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.dept_id IS '部门ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.user_name IS '用户账号';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.nick_name IS '用户昵称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.user_type IS '用户类型（00系统用户）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.email IS '用户邮箱';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.phonenumber IS '手机号码';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.sex IS '用户性别（0男 1女 2未知）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.avatar IS '头像地址';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.password IS '密码';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.status IS '帐号状态（0正常 1停用）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.del_flag IS '删除标志（0代表存在 2代表删除）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.login_ip IS '最后登录IP';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.login_date IS '最后登录时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user.remark IS '备注';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_post IS '岗位信息表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.post_id IS '岗位ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.post_code IS '岗位编码';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.post_name IS '岗位名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.post_sort IS '显示顺序';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.status IS '状态（0正常 1停用）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_post.remark IS '备注';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_role IS '角色信息表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.role_id IS '角色ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.role_name IS '角色名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.role_key IS '角色权限字符串';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.role_sort IS '显示顺序';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.data_scope IS '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.menu_check_strictly IS '菜单树选择项是否关联显示';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.dept_check_strictly IS '部门树选择项是否关联显示';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.status IS '角色状态（0正常 1停用）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.del_flag IS '删除标志（0代表存在 2代表删除）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role.remark IS '备注';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_menu IS '菜单权限表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.menu_id IS '菜单ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.menu_name IS '菜单名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.parent_id IS '父菜单ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.order_num IS '显示顺序';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.path IS '路由地址';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.component IS '组件路径';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.query IS '路由参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.is_frame IS '是否为外链（0是 1否）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.is_cache IS '是否缓存（0缓存 1不缓存）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.menu_type IS '菜单类型（M目录 C菜单 F按钮）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.visible IS '菜单状态（0显示 1隐藏）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.status IS '菜单状态（0正常 1停用）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.perms IS '权限标识';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.icon IS '菜单图标';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_menu.remark IS '备注';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_user_role IS '用户和角色关联表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user_role.user_id IS '用户ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user_role.role_id IS '角色ID';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_role_menu IS '角色和菜单关联表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role_menu.role_id IS '角色ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role_menu.menu_id IS '菜单ID';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_role_dept IS '角色和部门关联表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role_dept.role_id IS '角色ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_role_dept.dept_id IS '部门ID';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_user_post IS '用户与岗位关联表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user_post.user_id IS '用户ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_user_post.post_id IS '岗位ID';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_oper_log IS '操作日志记录';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.oper_id IS '日志主键';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.title IS '模块标题';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.business_type IS '业务类型（0其它 1新增 2修改 3删除）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.method IS '方法名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.request_method IS '请求方式';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.operator_type IS '操作类别（0其它 1后台用户 2手机端用户）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.oper_name IS '操作人员';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.dept_name IS '部门名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.oper_url IS '请求URL';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.oper_ip IS '主机地址';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.oper_location IS '操作地点';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.oper_param IS '请求参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.json_result IS '返回参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.status IS '操作状态（0正常 1异常）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.error_msg IS '错误消息';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.oper_time IS '操作时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_oper_log.cost_time IS '消耗时间';


COMMENT ON TABLE RY_VUE_SHENTONG.sys_dict_type IS '字典类型表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_type.dict_id IS '字典主键';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_type.dict_name IS '字典名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_type.dict_type IS '字典类型';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_type.status IS '状态（0正常 1停用）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_type.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_type.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_type.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_type.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_type.remark IS '备注';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_dict_data IS '字典数据表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.dict_code IS '字典编码';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.dict_sort IS '字典排序';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.dict_label IS '字典标签';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.dict_value IS '字典键值';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.dict_type IS '字典类型';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.css_class IS '样式属性（其他样式扩展）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.list_class IS '表格回显样式';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.is_default IS '是否默认（Y是 N否）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.status IS '状态（0正常 1停用）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_dict_data.remark IS '备注';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_config IS '参数配置表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.config_id IS '参数主键';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.config_name IS '参数名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.config_key IS '参数键名';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.config_value IS '参数键值';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.config_type IS '系统内置（Y是 N否）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_config.remark IS '备注';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_logininfor IS '系统访问记录';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_logininfor.info_id IS '访问ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_logininfor.user_name IS '用户账号';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_logininfor.ipaddr IS '登录IP地址';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_logininfor.login_location IS '登录地点';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_logininfor.browser IS '浏览器类型';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_logininfor.os IS '操作系统';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_logininfor.status IS '登录状态（0成功 1失败）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_logininfor.msg IS '提示消息';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_logininfor.login_time IS '访问时间';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_job IS '定时任务调度表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.job_id IS '任务ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.job_name IS '任务名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.job_group IS '任务组名';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.invoke_target IS '调用目标字符串';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.cron_expression IS 'cron执行表达式';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.misfire_policy IS '计划执行错误策略（1立即执行 2执行一次 3放弃执行）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.concurrent IS '是否并发执行（0允许 1禁止）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.status IS '状态（0正常 1暂停）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job.remark IS '备注信息';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_job_log IS '定时任务调度日志表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job_log.job_log_id IS '任务日志ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job_log.job_name IS '任务名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job_log.job_group IS '任务组名';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job_log.invoke_target IS '调用目标字符串';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job_log.job_message IS '日志信息';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job_log.status IS '执行状态（0正常 1失败）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job_log.exception_info IS '异常信息';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_job_log.create_time IS '创建时间';

COMMENT ON TABLE RY_VUE_SHENTONG.sys_notice IS '通知公告表';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.notice_id IS '公告ID';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.notice_title IS '公告标题';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.notice_type IS '公告类型（1通知 2公告）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.notice_content IS '公告内容';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.status IS '公告状态（0正常 1关闭）';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.sys_notice.remark IS '备注';

COMMENT ON TABLE RY_VUE_SHENTONG.gen_table IS '代码生成业务表';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.table_id IS '编号';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.table_name IS '表名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.table_comment IS '表描述';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.sub_table_name IS '关联子表的表名';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.sub_table_fk_name IS '子表关联的外键名';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.class_name IS '实体类名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.tpl_category IS '使用的模板（crud单表操作 tree树表操作）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.tpl_web_type IS '前端模板类型（element-ui模版 element-plus模版）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.package_name IS '生成包路径';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.module_name IS '生成模块名';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.business_name IS '生成业务名';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.function_name IS '生成功能名';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.function_author IS '生成功能作者';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.gen_type IS '生成代码方式（0zip压缩包 1自定义路径）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.gen_path IS '生成路径（不填默认项目路径）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.options IS '其它生成选项';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.update_time IS '更新时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table.remark IS '备注';


COMMENT ON TABLE RY_VUE_SHENTONG.gen_table_column IS '代码生成业务表字段';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.column_id IS '编号';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.table_id IS '归属表编号';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.column_name IS '列名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.column_comment IS '列描述';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.column_type IS '列类型';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.java_type IS 'JAVA类型';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.java_field IS 'JAVA字段名';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.is_pk IS '是否主键（1是）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.is_increment IS '是否自增（1是）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.is_required IS '是否必填（1是）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.is_insert IS '是否为插入字段（1是）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.is_edit IS '是否编辑字段（1是）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.is_list IS '是否列表字段（1是）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.is_query IS '是否查询字段（1是）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.query_type IS '查询方式（等于、不等于、大于、小于、范围）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.html_type IS '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.dict_type IS '字典类型';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.sort IS '排序';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.create_by IS '创建者';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.create_time IS '创建时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.update_by IS '更新者';
COMMENT ON COLUMN RY_VUE_SHENTONG.gen_table_column.update_time IS '更新时间';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_JOB_DETAILS IS '存储每一个已配置的 jobDetail 的详细信息';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.job_name IS '任务名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.job_group IS '任务组名';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.description IS '相关介绍';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.job_class_name IS '执行任务类名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.is_durable IS '是否持久化';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.is_nonconcurrent IS '是否并发';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.is_update_data IS '是否更新数据';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.requests_recovery IS '是否接受恢复执行';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_JOB_DETAILS.job_data IS '存放持久化job对象';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_TRIGGERS IS '存储已配置的 Trigger 的信息';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.trigger_name IS '触发器的名字';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.trigger_group IS '触发器所属组的名字';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.job_name IS 'qrtz_job_details表job_name的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.job_group IS 'qrtz_job_details表job_group的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.description IS '相关介绍';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.next_fire_time IS '上一次触发时间（毫秒）';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.prev_fire_time IS '下一次触发时间（默认为-1表示不触发）';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.priority IS '优先级';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.trigger_state IS '触发器状态';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.trigger_type IS '触发器的类型';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.start_time IS '开始时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.end_time IS '结束时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.calendar_name IS '日程表名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.misfire_instr IS '补偿执行的策略';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_TRIGGERS.job_data IS '存放持久化job对象';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_SIMPLE_TRIGGERS IS '存储简单的 Trigger，包括重复次数，间隔，以及已触发的次数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPLE_TRIGGERS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPLE_TRIGGERS.trigger_name IS 'qrtz_triggers表trigger_name的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPLE_TRIGGERS.trigger_group IS 'qrtz_triggers表trigger_group的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPLE_TRIGGERS.repeat_count IS '重复的次数统计';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPLE_TRIGGERS.repeat_interval IS '重复的间隔时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPLE_TRIGGERS.times_triggered IS '已经触发的次数';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_CRON_TRIGGERS IS '存储 Cron Trigger，包括 Cron 表达式和时区信息';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_CRON_TRIGGERS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_CRON_TRIGGERS.trigger_name IS 'qrtz_triggers表trigger_name的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_CRON_TRIGGERS.trigger_group IS 'qrtz_triggers表trigger_group的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_CRON_TRIGGERS.cron_expression IS 'cron表达式';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_CRON_TRIGGERS.time_zone_id IS '时区';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_BLOB_TRIGGERS IS 'Trigger 作为 Blob 类型存储(用于 Quartz 用户用 JDBC 创建他们自己定制的 Trigger 类型，JobStore 并不知道如何存储实例的时候)';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_BLOB_TRIGGERS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_BLOB_TRIGGERS.trigger_name IS 'qrtz_triggers表trigger_name的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_BLOB_TRIGGERS.trigger_group IS 'qrtz_triggers表trigger_group的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_BLOB_TRIGGERS.blob_data IS '存放持久化Trigger对象';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_CALENDARS IS '以 Blob 类型存储存放日历信息， quartz可配置一个日历来指定一个时间范围';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_CALENDARS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_CALENDARS.calendar_name IS '日历名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_CALENDARS.calendar IS '存放持久化calendar对象';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_PAUSED_TRIGGER_GRPS IS '存储已暂停的 Trigger 组的信息';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_PAUSED_TRIGGER_GRPS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_PAUSED_TRIGGER_GRPS.trigger_group IS 'qrtz_triggers表trigger_group的外键';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS IS '存储与已触发的 Trigger 相关的状态信息，以及相联 Job 的执行信息';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.entry_id IS '调度器实例id';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.trigger_name IS 'qrtz_triggers表trigger_name的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.trigger_group IS 'qrtz_triggers表trigger_group的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.instance_name IS '调度器实例名';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.fired_time IS '触发的时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.sched_time IS '定时器制定的时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.priority IS '优先级';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.state IS '状态';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.job_name IS '任务名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.job_group IS '任务组名';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.is_nonconcurrent IS '是否并发';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_FIRED_TRIGGERS.requests_recovery IS '是否接受恢复执行';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_SCHEDULER_STATE IS '存储少量的有关 Scheduler 的状态信息，假如是用于集群中，可以看到其他的 Scheduler 实例';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SCHEDULER_STATE.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SCHEDULER_STATE.instance_name IS '实例名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SCHEDULER_STATE.last_checkin_time IS '上次检查时间';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SCHEDULER_STATE.checkin_interval IS '检查间隔时间';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_LOCKS IS '存储程序的悲观锁的信息(假如使用了悲观锁)';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_LOCKS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_LOCKS.lock_name IS '悲观锁名称';

COMMENT ON TABLE RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS IS 'Quartz集群实现同步机制的行锁表';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.sched_name IS '调度名称';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.trigger_name IS 'qrtz_triggers表trigger_name的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.trigger_group IS 'qrtz_triggers表trigger_group的外键';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.str_prop_1 IS 'String类型的trigger的第一个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.str_prop_2 IS 'String类型的trigger的第二个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.str_prop_3 IS 'String类型的trigger的第三个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.int_prop_1 IS 'int类型的trigger的第一个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.int_prop_2 IS 'int类型的trigger的第二个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.long_prop_1 IS 'long类型的trigger的第一个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.long_prop_2 IS 'long类型的trigger的第二个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.dec_prop_1 IS 'decimal类型的trigger的第一个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.dec_prop_2 IS 'decimal类型的trigger的第二个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.bool_prop_1 IS 'Boolean类型的trigger的第一个参数';
COMMENT ON COLUMN RY_VUE_SHENTONG.QRTZ_SIMPROP_TRIGGERS.bool_prop_2 IS 'Boolean类型的trigger的第二个参数';





INSERT INTO RY_VUE_SHENTONG.SYS_CONFIG (CONFIG_ID,CONFIG_NAME,CONFIG_KEY,CONFIG_VALUE,CONFIG_TYPE,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1,'主框架页-默认皮肤样式名称','sys.index.skinName','skin-blue','Y','admin','2024-02-07 16:16:58.000','',NULL,'蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow')
,(2,'用户管理-账号初始密码','sys.user.initPassword','123456','Y','admin','2024-02-07 16:16:58.000','',NULL,'初始化密码 123456')
,(3,'主框架页-侧边栏主题','sys.index.sideTheme','theme-dark','Y','admin','2024-02-07 16:16:58.000','',NULL,'深色主题theme-dark，浅色主题theme-light')
,(4,'账号自助-验证码开关','sys.account.captchaEnabled','true','Y','admin','2024-02-07 16:16:58.000','',NULL,'是否开启验证码功能（true开启，false关闭）')
,(5,'账号自助-是否开启用户注册功能','sys.account.registerUser','false','Y','admin','2024-02-07 16:16:58.000','',NULL,'是否开启注册用户功能（true开启，false关闭）')
,(6,'用户登录-黑名单列表','sys.login.blackIPList','','Y','admin','2024-02-07 16:16:58.000','',NULL,'设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）')
;INSERT INTO RY_VUE_SHENTONG.SYS_DEPT (DEPT_ID,PARENT_ID,ANCESTORS,DEPT_NAME,ORDER_NUM,LEADER,PHONE,EMAIL,STATUS,DEL_FLAG,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME) VALUES 
(100,0,'0','若依科技',0,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
,(101,100,'0,100','深圳总公司',1,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
,(102,100,'0,100','长沙分公司',2,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
,(103,101,'0,100,101','研发部门',1,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
,(104,101,'0,100,101','市场部门',2,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
,(105,101,'0,100,101','测试部门',3,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
,(106,101,'0,100,101','财务部门',4,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
,(107,101,'0,100,101','运维部门',5,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
,(108,102,'0,100,102','市场部门',1,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
,(109,102,'0,100,102','财务部门',2,'若依','15888888888','ry@qq.com','0','0','admin','2024-02-07 16:16:57.000','',NULL)
;INSERT INTO RY_VUE_SHENTONG.SYS_DICT_DATA (DICT_CODE,DICT_SORT,DICT_LABEL,DICT_VALUE,DICT_TYPE,CSS_CLASS,LIST_CLASS,IS_DEFAULT,STATUS,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1,1,'男','0','sys_user_sex','','','Y','0','admin','2024-02-07 16:16:58.000','',NULL,'性别男')
,(2,2,'女','1','sys_user_sex','','','N','0','admin','2024-02-07 16:16:58.000','',NULL,'性别女')
,(3,3,'未知','2','sys_user_sex','','','N','0','admin','2024-02-07 16:16:58.000','',NULL,'性别未知')
,(4,1,'显示','0','sys_show_hide','','primary','Y','0','admin','2024-02-07 16:16:58.000','',NULL,'显示菜单')
,(5,2,'隐藏','1','sys_show_hide','','danger','N','0','admin','2024-02-07 16:16:58.000','',NULL,'隐藏菜单')
,(6,1,'正常','0','sys_normal_disable','','primary','Y','0','admin','2024-02-07 16:16:58.000','',NULL,'正常状态')
,(7,2,'停用','1','sys_normal_disable','','danger','N','0','admin','2024-02-07 16:16:58.000','',NULL,'停用状态')
,(8,1,'正常','0','sys_job_status','','primary','Y','0','admin','2024-02-07 16:16:58.000','',NULL,'正常状态')
,(9,2,'暂停','1','sys_job_status','','danger','N','0','admin','2024-02-07 16:16:58.000','',NULL,'停用状态')
,(10,1,'默认','DEFAULT','sys_job_group','','','Y','0','admin','2024-02-07 16:16:58.000','',NULL,'默认分组')
;
INSERT INTO RY_VUE_SHENTONG.SYS_DICT_DATA (DICT_CODE,DICT_SORT,DICT_LABEL,DICT_VALUE,DICT_TYPE,CSS_CLASS,LIST_CLASS,IS_DEFAULT,STATUS,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(11,2,'系统','SYSTEM','sys_job_group','','','N','0','admin','2024-02-07 16:16:58.000','',NULL,'系统分组')
,(12,1,'是','Y','sys_yes_no','','primary','Y','0','admin','2024-02-07 16:16:58.000','',NULL,'系统默认是')
,(13,2,'否','N','sys_yes_no','','danger','N','0','admin','2024-02-07 16:16:58.000','',NULL,'系统默认否')
,(14,1,'通知','1','sys_notice_type','','warning','Y','0','admin','2024-02-07 16:16:58.000','',NULL,'通知')
,(15,2,'公告','2','sys_notice_type','','success','N','0','admin','2024-02-07 16:16:58.000','',NULL,'公告')
,(16,1,'正常','0','sys_notice_status','','primary','Y','0','admin','2024-02-07 16:16:58.000','',NULL,'正常状态')
,(17,2,'关闭','1','sys_notice_status','','danger','N','0','admin','2024-02-07 16:16:58.000','',NULL,'关闭状态')
,(18,99,'其他','0','sys_oper_type','','info','N','0','admin','2024-02-07 16:16:58.000','',NULL,'其他操作')
,(19,1,'新增','1','sys_oper_type','','info','N','0','admin','2024-02-07 16:16:58.000','',NULL,'新增操作')
,(20,2,'修改','2','sys_oper_type','','info','N','0','admin','2024-02-07 16:16:58.000','',NULL,'修改操作')
;
INSERT INTO RY_VUE_SHENTONG.SYS_DICT_DATA (DICT_CODE,DICT_SORT,DICT_LABEL,DICT_VALUE,DICT_TYPE,CSS_CLASS,LIST_CLASS,IS_DEFAULT,STATUS,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(21,3,'删除','3','sys_oper_type','','danger','N','0','admin','2024-02-07 16:16:58.000','',NULL,'删除操作')
,(22,4,'授权','4','sys_oper_type','','primary','N','0','admin','2024-02-07 16:16:58.000','',NULL,'授权操作')
,(23,5,'导出','5','sys_oper_type','','warning','N','0','admin','2024-02-07 16:16:58.000','',NULL,'导出操作')
,(24,6,'导入','6','sys_oper_type','','warning','N','0','admin','2024-02-07 16:16:58.000','',NULL,'导入操作')
,(25,7,'强退','7','sys_oper_type','','danger','N','0','admin','2024-02-07 16:16:58.000','',NULL,'强退操作')
,(26,8,'生成代码','8','sys_oper_type','','warning','N','0','admin','2024-02-07 16:16:58.000','',NULL,'生成操作')
,(27,9,'清空数据','9','sys_oper_type','','danger','N','0','admin','2024-02-07 16:16:58.000','',NULL,'清空操作')
,(28,1,'成功','0','sys_common_status','','primary','N','0','admin','2024-02-07 16:16:58.000','',NULL,'正常状态')
,(29,2,'失败','1','sys_common_status','','danger','N','0','admin','2024-02-07 16:16:58.000','',NULL,'停用状态')
;INSERT INTO RY_VUE_SHENTONG.SYS_DICT_TYPE (DICT_ID,DICT_NAME,DICT_TYPE,STATUS,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1,'用户性别','sys_user_sex','0','admin','2024-02-07 16:16:58.000','',NULL,'用户性别列表')
,(2,'菜单状态','sys_show_hide','0','admin','2024-02-07 16:16:58.000','',NULL,'菜单状态列表')
,(3,'系统开关','sys_normal_disable','0','admin','2024-02-07 16:16:58.000','',NULL,'系统开关列表')
,(4,'任务状态','sys_job_status','0','admin','2024-02-07 16:16:58.000','',NULL,'任务状态列表')
,(5,'任务分组','sys_job_group','0','admin','2024-02-07 16:16:58.000','',NULL,'任务分组列表')
,(6,'系统是否','sys_yes_no','0','admin','2024-02-07 16:16:58.000','',NULL,'系统是否列表')
,(7,'通知类型','sys_notice_type','0','admin','2024-02-07 16:16:58.000','',NULL,'通知类型列表')
,(8,'通知状态','sys_notice_status','0','admin','2024-02-07 16:16:58.000','',NULL,'通知状态列表')
,(9,'操作类型','sys_oper_type','0','admin','2024-02-07 16:16:58.000','',NULL,'操作类型列表')
,(10,'系统状态','sys_common_status','0','admin','2024-02-07 16:16:58.000','',NULL,'登录状态列表')
;INSERT INTO RY_VUE_SHENTONG.SYS_JOB (JOB_ID,JOB_NAME,JOB_GROUP,INVOKE_TARGET,CRON_EXPRESSION,MISFIRE_POLICY,CONCURRENT,STATUS,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1,'系统默认（无参）','DEFAULT','ryTask.ryNoParams','0/10 * * * * ?','3','1','1','admin','2024-02-07 16:16:58.000','',NULL,'')
,(2,'系统默认（有参）','DEFAULT','ryTask.ryParams(''ry'')','0/15 * * * * ?','3','1','1','admin','2024-02-07 16:16:58.000','',NULL,'')
,(3,'系统默认（多参）','DEFAULT','ryTask.ryMultipleParams(''ry'', true, 2000L, 316.50D, 100)','0/20 * * * * ?','3','1','1','admin','2024-02-07 16:16:58.000','',NULL,'')
;INSERT INTO RY_VUE_SHENTONG.SYS_LOGININFOR (INFO_ID,USER_NAME,IPADDR,LOGIN_LOCATION,BROWSER,OS,STATUS,MSG,LOGIN_TIME) VALUES 
(100,'admin','127.0.0.1','内网IP','Chrome 12','Windows 10','1','验证码已失效','2024-02-07 16:45:41.000')
,(101,'admin','127.0.0.1','内网IP','Chrome 12','Windows 10','0','登录成功','2024-02-07 16:45:46.000')
;INSERT INTO RY_VUE_SHENTONG.SYS_MENU (MENU_ID,MENU_NAME,PARENT_ID,ORDER_NUM,"PATH",COMPONENT,"QUERY",IS_FRAME,IS_CACHE,MENU_TYPE,"VISIBLE",STATUS,PERMS,ICON,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1,'系统管理',0,1,'system',NULL,'',1,0,'M','0','0','','system','admin','2024-02-07 16:16:57.000','',NULL,'系统管理目录')
,(2,'系统监控',0,2,'monitor',NULL,'',1,0,'M','0','0','','monitor','admin','2024-02-07 16:16:57.000','',NULL,'系统监控目录')
,(3,'系统工具',0,3,'tool',NULL,'',1,0,'M','0','0','','tool','admin','2024-02-07 16:16:57.000','',NULL,'系统工具目录')
,(4,'若依官网',0,4,'http://ruoyi.vip',NULL,'',0,0,'M','0','0','','guide','admin','2024-02-07 16:16:57.000','',NULL,'若依官网地址')
,(100,'用户管理',1,1,'user','system/user/index','',1,0,'C','0','0','system:user:list','user','admin','2024-02-07 16:16:57.000','',NULL,'用户管理菜单')
,(101,'角色管理',1,2,'role','system/role/index','',1,0,'C','0','0','system:role:list','peoples','admin','2024-02-07 16:16:57.000','',NULL,'角色管理菜单')
,(102,'菜单管理',1,3,'menu','system/menu/index','',1,0,'C','0','0','system:menu:list','tree-table','admin','2024-02-07 16:16:57.000','',NULL,'菜单管理菜单')
,(103,'部门管理',1,4,'dept','system/dept/index','',1,0,'C','0','0','system:dept:list','tree','admin','2024-02-07 16:16:57.000','',NULL,'部门管理菜单')
,(104,'岗位管理',1,5,'post','system/post/index','',1,0,'C','0','0','system:post:list','post','admin','2024-02-07 16:16:57.000','',NULL,'岗位管理菜单')
,(105,'字典管理',1,6,'dict','system/dict/index','',1,0,'C','0','0','system:dict:list','dict','admin','2024-02-07 16:16:57.000','',NULL,'字典管理菜单')
;
INSERT INTO RY_VUE_SHENTONG.SYS_MENU (MENU_ID,MENU_NAME,PARENT_ID,ORDER_NUM,"PATH",COMPONENT,"QUERY",IS_FRAME,IS_CACHE,MENU_TYPE,"VISIBLE",STATUS,PERMS,ICON,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(106,'参数设置',1,7,'config','system/config/index','',1,0,'C','0','0','system:config:list','edit','admin','2024-02-07 16:16:57.000','',NULL,'参数设置菜单')
,(107,'通知公告',1,8,'notice','system/notice/index','',1,0,'C','0','0','system:notice:list','message','admin','2024-02-07 16:16:57.000','',NULL,'通知公告菜单')
,(108,'日志管理',1,9,'log','','',1,0,'M','0','0','','log','admin','2024-02-07 16:16:57.000','',NULL,'日志管理菜单')
,(109,'在线用户',2,1,'online','monitor/online/index','',1,0,'C','0','0','monitor:online:list','online','admin','2024-02-07 16:16:57.000','',NULL,'在线用户菜单')
,(110,'定时任务',2,2,'job','monitor/job/index','',1,0,'C','0','0','monitor:job:list','job','admin','2024-02-07 16:16:57.000','',NULL,'定时任务菜单')
,(111,'数据监控',2,3,'druid','monitor/druid/index','',1,0,'C','0','0','monitor:druid:list','druid','admin','2024-02-07 16:16:57.000','',NULL,'数据监控菜单')
,(112,'服务监控',2,4,'server','monitor/server/index','',1,0,'C','0','0','monitor:server:list','server','admin','2024-02-07 16:16:57.000','',NULL,'服务监控菜单')
,(113,'缓存监控',2,5,'cache','monitor/cache/index','',1,0,'C','0','0','monitor:cache:list','redis','admin','2024-02-07 16:16:57.000','',NULL,'缓存监控菜单')
,(114,'缓存列表',2,6,'cacheList','monitor/cache/list','',1,0,'C','0','0','monitor:cache:list','redis-list','admin','2024-02-07 16:16:57.000','',NULL,'缓存列表菜单')
,(115,'表单构建',3,1,'build','tool/build/index','',1,0,'C','0','0','tool:build:list','build','admin','2024-02-07 16:16:57.000','',NULL,'表单构建菜单')
;
INSERT INTO RY_VUE_SHENTONG.SYS_MENU (MENU_ID,MENU_NAME,PARENT_ID,ORDER_NUM,"PATH",COMPONENT,"QUERY",IS_FRAME,IS_CACHE,MENU_TYPE,"VISIBLE",STATUS,PERMS,ICON,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(116,'代码生成',3,2,'gen','tool/gen/index','',1,0,'C','0','0','tool:gen:list','code','admin','2024-02-07 16:16:57.000','',NULL,'代码生成菜单')
,(117,'系统接口',3,3,'swagger','tool/swagger/index','',1,0,'C','0','0','tool:swagger:list','swagger','admin','2024-02-07 16:16:57.000','',NULL,'系统接口菜单')
,(500,'操作日志',108,1,'operlog','monitor/operlog/index','',1,0,'C','0','0','monitor:operlog:list','form','admin','2024-02-07 16:16:57.000','',NULL,'操作日志菜单')
,(501,'登录日志',108,2,'logininfor','monitor/logininfor/index','',1,0,'C','0','0','monitor:logininfor:list','logininfor','admin','2024-02-07 16:16:57.000','',NULL,'登录日志菜单')
,(1000,'用户查询',100,1,'','','',1,0,'F','0','0','system:user:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1001,'用户新增',100,2,'','','',1,0,'F','0','0','system:user:add','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1002,'用户修改',100,3,'','','',1,0,'F','0','0','system:user:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1003,'用户删除',100,4,'','','',1,0,'F','0','0','system:user:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1004,'用户导出',100,5,'','','',1,0,'F','0','0','system:user:export','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1005,'用户导入',100,6,'','','',1,0,'F','0','0','system:user:import','#','admin','2024-02-07 16:16:57.000','',NULL,'')
;
INSERT INTO RY_VUE_SHENTONG.SYS_MENU (MENU_ID,MENU_NAME,PARENT_ID,ORDER_NUM,"PATH",COMPONENT,"QUERY",IS_FRAME,IS_CACHE,MENU_TYPE,"VISIBLE",STATUS,PERMS,ICON,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1006,'重置密码',100,7,'','','',1,0,'F','0','0','system:user:resetPwd','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1007,'角色查询',101,1,'','','',1,0,'F','0','0','system:role:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1008,'角色新增',101,2,'','','',1,0,'F','0','0','system:role:add','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1009,'角色修改',101,3,'','','',1,0,'F','0','0','system:role:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1010,'角色删除',101,4,'','','',1,0,'F','0','0','system:role:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1011,'角色导出',101,5,'','','',1,0,'F','0','0','system:role:export','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1012,'菜单查询',102,1,'','','',1,0,'F','0','0','system:menu:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1013,'菜单新增',102,2,'','','',1,0,'F','0','0','system:menu:add','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1014,'菜单修改',102,3,'','','',1,0,'F','0','0','system:menu:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1015,'菜单删除',102,4,'','','',1,0,'F','0','0','system:menu:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
;
INSERT INTO RY_VUE_SHENTONG.SYS_MENU (MENU_ID,MENU_NAME,PARENT_ID,ORDER_NUM,"PATH",COMPONENT,"QUERY",IS_FRAME,IS_CACHE,MENU_TYPE,"VISIBLE",STATUS,PERMS,ICON,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1016,'部门查询',103,1,'','','',1,0,'F','0','0','system:dept:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1017,'部门新增',103,2,'','','',1,0,'F','0','0','system:dept:add','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1018,'部门修改',103,3,'','','',1,0,'F','0','0','system:dept:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1019,'部门删除',103,4,'','','',1,0,'F','0','0','system:dept:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1020,'岗位查询',104,1,'','','',1,0,'F','0','0','system:post:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1021,'岗位新增',104,2,'','','',1,0,'F','0','0','system:post:add','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1022,'岗位修改',104,3,'','','',1,0,'F','0','0','system:post:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1023,'岗位删除',104,4,'','','',1,0,'F','0','0','system:post:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1024,'岗位导出',104,5,'','','',1,0,'F','0','0','system:post:export','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1025,'字典查询',105,1,'#','','',1,0,'F','0','0','system:dict:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
;
INSERT INTO RY_VUE_SHENTONG.SYS_MENU (MENU_ID,MENU_NAME,PARENT_ID,ORDER_NUM,"PATH",COMPONENT,"QUERY",IS_FRAME,IS_CACHE,MENU_TYPE,"VISIBLE",STATUS,PERMS,ICON,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1026,'字典新增',105,2,'#','','',1,0,'F','0','0','system:dict:add','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1027,'字典修改',105,3,'#','','',1,0,'F','0','0','system:dict:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1028,'字典删除',105,4,'#','','',1,0,'F','0','0','system:dict:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1029,'字典导出',105,5,'#','','',1,0,'F','0','0','system:dict:export','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1030,'参数查询',106,1,'#','','',1,0,'F','0','0','system:config:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1031,'参数新增',106,2,'#','','',1,0,'F','0','0','system:config:add','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1032,'参数修改',106,3,'#','','',1,0,'F','0','0','system:config:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1033,'参数删除',106,4,'#','','',1,0,'F','0','0','system:config:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1034,'参数导出',106,5,'#','','',1,0,'F','0','0','system:config:export','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1035,'公告查询',107,1,'#','','',1,0,'F','0','0','system:notice:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
;
INSERT INTO RY_VUE_SHENTONG.SYS_MENU (MENU_ID,MENU_NAME,PARENT_ID,ORDER_NUM,"PATH",COMPONENT,"QUERY",IS_FRAME,IS_CACHE,MENU_TYPE,"VISIBLE",STATUS,PERMS,ICON,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1036,'公告新增',107,2,'#','','',1,0,'F','0','0','system:notice:add','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1037,'公告修改',107,3,'#','','',1,0,'F','0','0','system:notice:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1038,'公告删除',107,4,'#','','',1,0,'F','0','0','system:notice:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1039,'操作查询',500,1,'#','','',1,0,'F','0','0','monitor:operlog:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1040,'操作删除',500,2,'#','','',1,0,'F','0','0','monitor:operlog:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1041,'日志导出',500,3,'#','','',1,0,'F','0','0','monitor:operlog:export','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1042,'登录查询',501,1,'#','','',1,0,'F','0','0','monitor:logininfor:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1043,'登录删除',501,2,'#','','',1,0,'F','0','0','monitor:logininfor:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1044,'日志导出',501,3,'#','','',1,0,'F','0','0','monitor:logininfor:export','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1045,'账户解锁',501,4,'#','','',1,0,'F','0','0','monitor:logininfor:unlock','#','admin','2024-02-07 16:16:57.000','',NULL,'')
;
INSERT INTO RY_VUE_SHENTONG.SYS_MENU (MENU_ID,MENU_NAME,PARENT_ID,ORDER_NUM,"PATH",COMPONENT,"QUERY",IS_FRAME,IS_CACHE,MENU_TYPE,"VISIBLE",STATUS,PERMS,ICON,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1046,'在线查询',109,1,'#','','',1,0,'F','0','0','monitor:online:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1047,'批量强退',109,2,'#','','',1,0,'F','0','0','monitor:online:batchLogout','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1048,'单条强退',109,3,'#','','',1,0,'F','0','0','monitor:online:forceLogout','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1049,'任务查询',110,1,'#','','',1,0,'F','0','0','monitor:job:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1050,'任务新增',110,2,'#','','',1,0,'F','0','0','monitor:job:add','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1051,'任务修改',110,3,'#','','',1,0,'F','0','0','monitor:job:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1052,'任务删除',110,4,'#','','',1,0,'F','0','0','monitor:job:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1053,'状态修改',110,5,'#','','',1,0,'F','0','0','monitor:job:changeStatus','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1054,'任务导出',110,6,'#','','',1,0,'F','0','0','monitor:job:export','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1055,'生成查询',116,1,'#','','',1,0,'F','0','0','tool:gen:query','#','admin','2024-02-07 16:16:57.000','',NULL,'')
;
INSERT INTO RY_VUE_SHENTONG.SYS_MENU (MENU_ID,MENU_NAME,PARENT_ID,ORDER_NUM,"PATH",COMPONENT,"QUERY",IS_FRAME,IS_CACHE,MENU_TYPE,"VISIBLE",STATUS,PERMS,ICON,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1056,'生成修改',116,2,'#','','',1,0,'F','0','0','tool:gen:edit','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1057,'生成删除',116,3,'#','','',1,0,'F','0','0','tool:gen:remove','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1058,'导入代码',116,4,'#','','',1,0,'F','0','0','tool:gen:import','#','admin','2024-02-07 16:16:57.000','',NULL,'')
,(1059,'预览代码',116,5,'#','','',1,0,'F','0','0','tool:gen:preview','#','admin','2024-02-07 16:16:58.000','',NULL,'')
,(1060,'生成代码',116,6,'#','','',1,0,'F','0','0','tool:gen:code','#','admin','2024-02-07 16:16:58.000','',NULL,'')
;
INSERT INTO RY_VUE_SHENTONG.SYS_POST (POST_ID,POST_CODE,POST_NAME,POST_SORT,STATUS,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1,'ceo','董事长',1,'0','admin','2024-02-07 16:16:57.000','',NULL,'')
,(2,'se','项目经理',2,'0','admin','2024-02-07 16:16:57.000','',NULL,'')
,(3,'hr','人力资源',3,'0','admin','2024-02-07 16:16:57.000','',NULL,'')
,(4,'user','普通员工',4,'0','admin','2024-02-07 16:16:57.000','',NULL,'')
;INSERT INTO RY_VUE_SHENTONG.SYS_ROLE (ROLE_ID,ROLE_NAME,ROLE_KEY,ROLE_SORT,DATA_SCOPE,MENU_CHECK_STRICTLY,DEPT_CHECK_STRICTLY,STATUS,DEL_FLAG,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1,'超级管理员','admin',1,'1',1,1,'0','0','admin','2024-02-07 16:16:57.000','',NULL,'超级管理员')
,(2,'普通角色','common',2,'2',1,1,'0','0','admin','2024-02-07 16:16:57.000','',NULL,'普通角色')
;INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_DEPT (ROLE_ID,DEPT_ID) VALUES 
(2,100)
,(2,101)
,(2,105)
;INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_MENU (ROLE_ID,MENU_ID) VALUES 
(2,1)
,(2,2)
,(2,3)
,(2,4)
,(2,100)
,(2,101)
,(2,102)
,(2,103)
,(2,104)
,(2,105)
;
INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_MENU (ROLE_ID,MENU_ID) VALUES 
(2,106)
,(2,107)
,(2,108)
,(2,109)
,(2,110)
,(2,111)
,(2,112)
,(2,113)
,(2,114)
,(2,115)
;
INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_MENU (ROLE_ID,MENU_ID) VALUES 
(2,116)
,(2,117)
,(2,500)
,(2,501)
,(2,1000)
,(2,1001)
,(2,1002)
,(2,1003)
,(2,1004)
,(2,1005)
;
INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_MENU (ROLE_ID,MENU_ID) VALUES 
(2,1006)
,(2,1007)
,(2,1008)
,(2,1009)
,(2,1010)
,(2,1011)
,(2,1012)
,(2,1013)
,(2,1014)
,(2,1015)
;
INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_MENU (ROLE_ID,MENU_ID) VALUES 
(2,1016)
,(2,1017)
,(2,1018)
,(2,1019)
,(2,1020)
,(2,1021)
,(2,1022)
,(2,1023)
,(2,1024)
,(2,1025)
;
INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_MENU (ROLE_ID,MENU_ID) VALUES 
(2,1026)
,(2,1027)
,(2,1028)
,(2,1029)
,(2,1030)
,(2,1031)
,(2,1032)
,(2,1033)
,(2,1034)
,(2,1035)
;
INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_MENU (ROLE_ID,MENU_ID) VALUES 
(2,1036)
,(2,1037)
,(2,1038)
,(2,1039)
,(2,1040)
,(2,1041)
,(2,1042)
,(2,1043)
,(2,1044)
,(2,1045)
;
INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_MENU (ROLE_ID,MENU_ID) VALUES 
(2,1046)
,(2,1047)
,(2,1048)
,(2,1049)
,(2,1050)
,(2,1051)
,(2,1052)
,(2,1053)
,(2,1054)
,(2,1055)
;
INSERT INTO RY_VUE_SHENTONG.SYS_ROLE_MENU (ROLE_ID,MENU_ID) VALUES 
(2,1056)
,(2,1057)
,(2,1058)
,(2,1059)
,(2,1060)
;INSERT INTO RY_VUE_SHENTONG.SYS_USER (USER_ID,DEPT_ID,USER_NAME,NICK_NAME,USER_TYPE,EMAIL,PHONENUMBER,SEX,AVATAR,"PASSWORD",STATUS,DEL_FLAG,LOGIN_IP,LOGIN_DATE,CREATE_BY,CREATE_TIME,UPDATE_BY,UPDATE_TIME,REMARK) VALUES 
(1,103,'admin','若依','00','ry@163.com','15888888888','1','','$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2','0','0','127.0.0.1','2024-02-07 16:45:46.000','admin','2024-02-07 16:16:57.000','','2024-02-07 16:45:46.000','管理员')
,(2,105,'ry','若依','00','ry@qq.com','15666666666','1','','$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2','0','0','127.0.0.1','2024-02-07 16:16:57.000','admin','2024-02-07 16:16:57.000','',NULL,'测试员')
;INSERT INTO RY_VUE_SHENTONG.SYS_USER_POST (USER_ID,POST_ID) VALUES 
(1,1)
,(2,2)
;INSERT INTO RY_VUE_SHENTONG.SYS_USER_ROLE (USER_ID,ROLE_ID) VALUES 
(1,1)
,(2,2)
;